-
Junior Member
Can somebody help me out
hi....
Can somebody help me out in this issue..
As my server consists of number of databases , so i want to create sub folders under databases as its creating a confusion ...could this be possible in Sql Server 2000.
Eg:
1a
2a
3a
4a
1b
2b
3b
4b
I want these in 2 sub folders 'a' and 'b'
-
Re: Can somebody help me out
form your post i am not at all sure what exactlyyou want to achieve by creating subfolders . Please post that clearly again.
-
Junior Member
Re: Can somebody help me out
I Heard that we can create the sub folders in the database section. Is that possible.can u plz tell me
Last edited by pooja_tin; 08-10-2007 at 08:18 AM.
-
Junior Member
Re: Can somebody help me out
in object explorer right click on the database and create new folder u want to server as database
To use the particular database try out this cmd
use
go
select these statements in click execute
the cmds that are execute d after this wll be in that database
-
Junior Member
Re: Can somebody help me out
In sql serer 2000 in each of the databases there are
.mdf and .ldf
You can have a copy for each of the databases.Ex 1a,1b,2a,2b..............
When ever you want you can load these files to any of the databases.
-
Junior Member
Re: Can somebody help me out
Just goto Enterprize manager there right click mouse on database..click new database....then u can view of the new database ...in query analyzer we can use use which u created previously.....then u can use that database name........
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules